Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 2506983 |
| Missing cells | 569378 |
| Missing cells (%) | 1.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.2 GiB |
| Average record size in memory | 512.4 B |
Variable types
| NUM | 8 |
|---|---|
| CAT | 5 |
| BOOL | 1 |
Reproduction
| Analysis started | 2020-07-12 17:17:33.546041 |
|---|---|
| Analysis finished | 2020-07-12 17:20:35.299374 |
| Duration | 3 minutes and 1.75 second |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
start_time has a high cardinality: 2502118 distinct values | High cardinality |
end_time has a high cardinality: 2502116 distinct values | High cardinality |
start_station_name has a high cardinality: 446 distinct values | High cardinality |
end_station_name has a high cardinality: 446 distinct values | High cardinality |
end_station_longitude is highly correlated with end_station_latitude | High correlation |
end_station_latitude is highly correlated with end_station_longitude | High correlation |
start_station_id has 80734 (3.2%) missing values | Missing |
start_station_name has 80133 (3.2%) missing values | Missing |
end_station_id has 82902 (3.3%) missing values | Missing |
end_station_name has 82350 (3.3%) missing values | Missing |
bike_share_for_all_trip has 243259 (9.7%) missing values | Missing |
duration_sec is highly skewed (γ1 = 61.41479711) | Skewed |
start_station_latitude is highly skewed (γ1 = -103.0494041) | Skewed |
start_station_longitude is highly skewed (γ1 = 309.5870215) | Skewed |
end_station_latitude is highly skewed (γ1 = -125.689168) | Skewed |
end_station_longitude is highly skewed (γ1 = 165.6630369) | Skewed |
start_time is uniformly distributed | Uniform |
end_time is uniformly distributed | Uniform |
| Distinct count | 15280 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 807.6483298849653 |
|---|---|
| Minimum | 60 |
| Maximum | 912110 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | 60 |
|---|---|
| 5-th percentile | 182 |
| Q1 | 359 |
| median | 571 |
| Q3 | 887 |
| 95-th percentile | 1760 |
| Maximum | 912110 |
| Range | 912050 |
| Interquartile range (IQR) | 528 |
Descriptive statistics
| Standard deviation | 1974.713981 |
|---|---|
| Coefficient of variation (CV) | 2.445017104 |
| Kurtosis | 18790.78908 |
| Mean | 807.6483299 |
| Median Absolute Deviation (MAD) | 246 |
| Skewness | 61.41479711 |
| Sum | 2024760633 |
| Variance | 3899495.305 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 339 | 3298 | 0.1% | |
| 370 | 3268 | 0.1% | |
| 372 | 3251 | 0.1% | |
| 353 | 3244 | 0.1% | |
| 355 | 3242 | 0.1% | |
| 383 | 3236 | 0.1% | |
| 390 | 3233 | 0.1% | |
| 324 | 3231 | 0.1% | |
| 375 | 3221 | 0.1% | |
| 340 | 3218 | 0.1% | |
| 380 | 3214 | 0.1% | |
| 384 | 3214 | 0.1% | |
| 364 | 3213 | 0.1% | |
| 358 | 3213 | 0.1% | |
| 313 | 3212 | 0.1% | |
| 349 | 3212 | 0.1% | |
| 387 | 3208 | 0.1% | |
| 327 | 3206 | 0.1% | |
| 395 | 3206 | 0.1% | |
| 359 | 3205 | 0.1% | |
| 386 | 3204 | 0.1% | |
| 396 | 3203 | 0.1% | |
| 381 | 3202 | 0.1% | |
| 347 | 3201 | 0.1% | |
| 346 | 3199 | 0.1% | |
| Other values (15255) | 2426429 | 96.8% |
| Value | Count | Frequency (%) | |
| 60 | 38 | < 0.1% | |
| 61 | 298 | < 0.1% | |
| 62 | 291 | < 0.1% | |
| 63 | 307 | < 0.1% | |
| 64 | 288 | < 0.1% | |
| 65 | 300 | < 0.1% | |
| 66 | 324 | < 0.1% | |
| 67 | 317 | < 0.1% | |
| 68 | 318 | < 0.1% | |
| 69 | 341 | < 0.1% |
| Value | Count | Frequency (%) | |
| 912110 | 1 | < 0.1% | |
| 86230 | 1 | < 0.1% | |
| 86217 | 1 | < 0.1% | |
| 86114 | 2 | < 0.1% | |
| 85952 | 1 | < 0.1% | |
| 85935 | 1 | < 0.1% | |
| 85904 | 1 | < 0.1% | |
| 85702 | 1 | < 0.1% | |
| 85676 | 1 | < 0.1% | |
| 85545 | 1 | < 0.1% |
| Distinct count | 2502118 |
|---|---|
| Unique (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.1 MiB |
| 2019-07-30 07:59:17 | 5 |
|---|---|
| 2019-07-31 08:25:09 | 4 |
| 2019-07-27 18:57:16 | 4 |
| 2019-07-24 08:46:17 | 4 |
| 2019-07-25 07:51:36 | 4 |
| Other values (2502113) |
| Value | Count | Frequency (%) | |
| 2019-07-30 07:59:17 | 5 | < 0.1% | |
| 2019-07-31 08:25:09 | 4 | < 0.1% | |
| 2019-07-27 18:57:16 | 4 | < 0.1% | |
| 2019-07-24 08:46:17 | 4 | < 0.1% | |
| 2019-07-25 07:51:36 | 4 | < 0.1% | |
| 2019-07-24 08:57:12 | 4 | < 0.1% | |
| 2019-07-27 17:23:45 | 4 | < 0.1% | |
| 2019-07-23 08:31:17 | 4 | < 0.1% | |
| 2019-07-24 07:58:16 | 3 | < 0.1% | |
| 2019-07-22 17:27:10 | 3 | < 0.1% | |
| 2019-07-30 12:19:03 | 3 | < 0.1% | |
| 2019-07-29 08:39:02 | 3 | < 0.1% | |
| 2019-07-27 12:23:02 | 3 | < 0.1% | |
| 2019-07-21 15:39:48 | 3 | < 0.1% | |
| 2019-07-23 17:04:53 | 3 | < 0.1% | |
| 2019-07-22 12:51:23 | 3 | < 0.1% | |
| 2019-07-27 15:41:20 | 3 | < 0.1% | |
| 2019-07-26 17:51:04 | 3 | < 0.1% | |
| 2019-07-23 17:16:24 | 3 | < 0.1% | |
| 2019-07-25 12:15:39 | 3 | < 0.1% | |
| 2019-07-24 09:23:32 | 3 | < 0.1% | |
| 2019-07-27 15:40:15 | 3 | < 0.1% | |
| 2019-07-28 16:18:45 | 3 | < 0.1% | |
| 2019-07-25 08:24:20 | 3 | < 0.1% | |
| 2019-07-24 09:11:09 | 3 | < 0.1% | |
| Other values (2502093) | 2506899 | > 99.9% |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 23.75899717 |
| Min length | 19 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 11032963 | 18.5% | |
| 1 | 8383773 | 14.1% | |
| 2 | 6351336 | 10.7% | |
| - | 5013966 | 8.4% | |
| : | 5013966 | 8.4% | |
| 9 | 4548090 | 7.6% | |
| 3 | 2819146 | 4.7% | |
| 4 | 2658182 | 4.5% | |
| 5 | 2613318 | 4.4% | |
| 2506983 | 4.2% | ||
| . | 2386145 | 4.0% | |
| 8 | 2188453 | 3.7% | |
| 7 | 2153782 | 3.6% | |
| 6 | 1893299 | 3.2% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 44642342 | 74.9% | |
| Other Punctuation | 7400111 | 12.4% | |
| Dash Punctuation | 5013966 | 8.4% | |
| Space Separator | 2506983 | 4.2% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 11032963 | 24.7% | |
| 1 | 8383773 | 18.8% | |
| 2 | 6351336 | 14.2% | |
| 9 | 4548090 | 10.2% | |
| 3 | 2819146 | 6.3% | |
| 4 | 2658182 | 6.0% | |
| 5 | 2613318 | 5.9% | |
| 8 | 2188453 | 4.9% | |
| 7 | 2153782 | 4.8% | |
| 6 | 1893299 | 4.2% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 5013966 | 100.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 2506983 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| : | 5013966 | 67.8% | |
| . | 2386145 | 32.2% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 59563402 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 11032963 | 18.5% | |
| 1 | 8383773 | 14.1% | |
| 2 | 6351336 | 10.7% | |
| - | 5013966 | 8.4% | |
| : | 5013966 | 8.4% | |
| 9 | 4548090 | 7.6% | |
| 3 | 2819146 | 4.7% | |
| 4 | 2658182 | 4.5% | |
| 5 | 2613318 | 4.4% | |
| 2506983 | 4.2% | ||
| . | 2386145 | 4.0% | |
| 8 | 2188453 | 3.7% | |
| 7 | 2153782 | 3.6% | |
| 6 | 1893299 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 59563402 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 11032963 | 18.5% | |
| 1 | 8383773 | 14.1% | |
| 2 | 6351336 | 10.7% | |
| - | 5013966 | 8.4% | |
| : | 5013966 | 8.4% | |
| 9 | 4548090 | 7.6% | |
| 3 | 2819146 | 4.7% | |
| 4 | 2658182 | 4.5% | |
| 5 | 2613318 | 4.4% | |
| 2506983 | 4.2% | ||
| . | 2386145 | 4.0% | |
| 8 | 2188453 | 3.7% | |
| 7 | 2153782 | 3.6% | |
| 6 | 1893299 | 3.2% |
| Distinct count | 2502116 |
|---|---|
| Unique (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.1 MiB |
| 2019-07-22 08:35:41 | 4 |
|---|---|
| 2019-07-25 10:30:53 | 4 |
| 2019-07-27 18:08:44 | 4 |
| 2019-07-26 10:04:08 | 4 |
| 2019-07-25 08:17:40 | 4 |
| Other values (2502111) |
| Value | Count | Frequency (%) | |
| 2019-07-22 08:35:41 | 4 | < 0.1% | |
| 2019-07-25 10:30:53 | 4 | < 0.1% | |
| 2019-07-27 18:08:44 | 4 | < 0.1% | |
| 2019-07-26 10:04:08 | 4 | < 0.1% | |
| 2019-07-25 08:17:40 | 4 | < 0.1% | |
| 2019-07-26 18:19:52 | 3 | < 0.1% | |
| 2019-07-30 17:20:54 | 3 | < 0.1% | |
| 2019-07-28 15:50:47 | 3 | < 0.1% | |
| 2019-07-29 08:38:39 | 3 | < 0.1% | |
| 2019-07-26 13:53:14 | 3 | < 0.1% | |
| 2019-07-25 17:26:23 | 3 | < 0.1% | |
| 2019-07-24 07:54:38 | 3 | < 0.1% | |
| 2019-07-31 07:54:41 | 3 | < 0.1% | |
| 2019-07-26 17:25:13 | 3 | < 0.1% | |
| 2019-07-24 11:52:18 | 3 | < 0.1% | |
| 2019-07-22 12:27:28 | 3 | < 0.1% | |
| 2019-07-20 13:20:18 | 3 | < 0.1% | |
| 2019-07-22 19:14:24 | 3 | < 0.1% | |
| 2019-07-31 08:56:48 | 3 | < 0.1% | |
| 2019-07-23 17:28:31 | 3 | < 0.1% | |
| 2019-07-19 09:32:09 | 3 | < 0.1% | |
| 2019-07-23 06:52:38 | 3 | < 0.1% | |
| 2019-07-31 08:51:24 | 3 | < 0.1% | |
| 2019-07-20 17:26:41 | 3 | < 0.1% | |
| 2019-07-26 18:44:37 | 3 | < 0.1% | |
| Other values (2502091) | 2506903 | > 99.9% |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 23.75899717 |
| Min length | 19 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 11014233 | 18.5% | |
| 1 | 8377903 | 14.1% | |
| 2 | 6406658 | 10.8% | |
| - | 5013966 | 8.4% | |
| : | 5013966 | 8.4% | |
| 9 | 4587894 | 7.7% | |
| 3 | 2816163 | 4.7% | |
| 4 | 2636400 | 4.4% | |
| 5 | 2624607 | 4.4% | |
| 2506983 | 4.2% | ||
| . | 2386145 | 4.0% | |
| 8 | 2190284 | 3.7% | |
| 7 | 2118315 | 3.6% | |
| 6 | 1869885 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 44642342 | 74.9% | |
| Other Punctuation | 7400111 | 12.4% | |
| Dash Punctuation | 5013966 | 8.4% | |
| Space Separator | 2506983 | 4.2% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 11014233 | 24.7% | |
| 1 | 8377903 | 18.8% | |
| 2 | 6406658 | 14.4% | |
| 9 | 4587894 | 10.3% | |
| 3 | 2816163 | 6.3% | |
| 4 | 2636400 | 5.9% | |
| 5 | 2624607 | 5.9% | |
| 8 | 2190284 | 4.9% | |
| 7 | 2118315 | 4.7% | |
| 6 | 1869885 | 4.2% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 5013966 | 100.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 2506983 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| : | 5013966 | 67.8% | |
| . | 2386145 | 32.2% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 59563402 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 11014233 | 18.5% | |
| 1 | 8377903 | 14.1% | |
| 2 | 6406658 | 10.8% | |
| - | 5013966 | 8.4% | |
| : | 5013966 | 8.4% | |
| 9 | 4587894 | 7.7% | |
| 3 | 2816163 | 4.7% | |
| 4 | 2636400 | 4.4% | |
| 5 | 2624607 | 4.4% | |
| 2506983 | 4.2% | ||
| . | 2386145 | 4.0% | |
| 8 | 2190284 | 3.7% | |
| 7 | 2118315 | 3.6% | |
| 6 | 1869885 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 59563402 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 11014233 | 18.5% | |
| 1 | 8377903 | 14.1% | |
| 2 | 6406658 | 10.8% | |
| - | 5013966 | 8.4% | |
| : | 5013966 | 8.4% | |
| 9 | 4587894 | 7.7% | |
| 3 | 2816163 | 4.7% | |
| 4 | 2636400 | 4.4% | |
| 5 | 2624607 | 4.4% | |
| 2506983 | 4.2% | ||
| . | 2386145 | 4.0% | |
| 8 | 2190284 | 3.7% | |
| 7 | 2118315 | 3.6% | |
| 6 | 1869885 | 3.1% |
| Distinct count | 436 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80734 |
| Missing (%) | 3.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 146.50474910036027 |
|---|---|
| Minimum | 3.0 |
| Maximum | 498.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 47 |
| median | 105 |
| Q3 | 243 |
| 95-th percentile | 376 |
| Maximum | 498 |
| Range | 495 |
| Interquartile range (IQR) | 196 |
Descriptive statistics
| Standard deviation | 122.3171024 |
|---|---|
| Coefficient of variation (CV) | 0.8349019614 |
| Kurtosis | -0.5575613587 |
| Mean | 146.5047491 |
| Median Absolute Deviation (MAD) | 79 |
| Skewness | 0.7718204869 |
| Sum | 355457001 |
| Variance | 14961.47353 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 58 | 45058 | 1.8% | |
| 81 | 42962 | 1.7% | |
| 30 | 40302 | 1.6% | |
| 15 | 39016 | 1.6% | |
| 67 | 36576 | 1.5% | |
| 21 | 36081 | 1.4% | |
| 3 | 34253 | 1.4% | |
| 16 | 32448 | 1.3% | |
| 22 | 31341 | 1.3% | |
| 5 | 30581 | 1.2% | |
| 6 | 28785 | 1.1% | |
| 50 | 24424 | 1.0% | |
| 66 | 23093 | 0.9% | |
| 17 | 22094 | 0.9% | |
| 93 | 21437 | 0.9% | |
| 90 | 21116 | 0.8% | |
| 27 | 20818 | 0.8% | |
| 44 | 20551 | 0.8% | |
| 104 | 20015 | 0.8% | |
| 23 | 19219 | 0.8% | |
| 61 | 18335 | 0.7% | |
| 243 | 17302 | 0.7% | |
| 19 | 17158 | 0.7% | |
| 114 | 17100 | 0.7% | |
| 350 | 16127 | 0.6% | |
| Other values (411) | 1750057 | 69.8% | |
| (Missing) | 80734 | 3.2% |
| Value | Count | Frequency (%) | |
| 3 | 34253 | 1.4% | |
| 4 | 7115 | 0.3% | |
| 5 | 30581 | 1.2% | |
| 6 | 28785 | 1.1% | |
| 7 | 10068 | 0.4% | |
| 8 | 10514 | 0.4% | |
| 9 | 10584 | 0.4% | |
| 10 | 9533 | 0.4% | |
| 11 | 11752 | 0.5% | |
| 12 | 3379 | 0.1% |
| Value | Count | Frequency (%) | |
| 498 | 11 | < 0.1% | |
| 495 | 22 | < 0.1% | |
| 494 | 20 | < 0.1% | |
| 493 | 388 | < 0.1% | |
| 492 | 69 | < 0.1% | |
| 491 | 39 | < 0.1% | |
| 490 | 42 | < 0.1% | |
| 489 | 46 | < 0.1% | |
| 488 | 16 | < 0.1% | |
| 487 | 391 | < 0.1% |
| Distinct count | 446 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80133 |
| Missing (%) | 3.2% |
| Memory size | 19.1 MiB |
| Market St at 10th St | 45058 |
|---|---|
| Berry St at 4th St | 42962 |
| San Francisco Caltrain (Townsend St at 4th St) | 40302 |
| San Francisco Ferry Building (Harry Bridges Plaza) | 39016 |
| San Francisco Caltrain Station 2 (Townsend St at 4th St) | 36576 |
| Other values (441) |
| Value | Count | Frequency (%) | |
| Market St at 10th St | 45058 | 1.8% | |
| Berry St at 4th St | 42962 | 1.7% | |
| San Francisco Caltrain (Townsend St at 4th St) | 40302 | 1.6% | |
| San Francisco Ferry Building (Harry Bridges Plaza) | 39016 | 1.6% | |
| San Francisco Caltrain Station 2 (Townsend St at 4th St) | 36576 | 1.5% | |
| Montgomery St BART Station (Market St at 2nd St) | 36081 | 1.4% | |
| Powell St BART Station (Market St at 4th St) | 34253 | 1.4% | |
| Steuart St at Market St | 32448 | 1.3% | |
| Howard St at Beale St | 31341 | 1.3% | |
| Powell St BART Station (Market St at 5th St) | 30581 | 1.2% | |
| The Embarcadero at Sansome St | 28785 | 1.1% | |
| 2nd St at Townsend St | 24424 | 1.0% | |
| 3rd St at Townsend St | 23093 | 0.9% | |
| Embarcadero BART Station (Beale St at Market St) | 22094 | 0.9% | |
| 4th St at Mission Bay Blvd S | 21437 | 0.9% | |
| Townsend St at 7th St | 21116 | 0.8% | |
| Beale St at Harrison St | 20818 | 0.8% | |
| Civic Center/UN Plaza BART Station (Market St at McAllister St) | 20551 | 0.8% | |
| 4th St at 16th St | 20015 | 0.8% | |
| The Embarcadero at Steuart St | 19219 | 0.8% | |
| Howard St at 8th St | 18335 | 0.7% | |
| Bancroft Way at College Ave | 17302 | 0.7% | |
| Post St at Kearny St | 17158 | 0.7% | |
| Rhode Island St at 17th St | 17100 | 0.7% | |
| 8th St at Brannan St | 16127 | 0.6% | |
| Other values (421) | 1750658 | 69.8% | |
| (Missing) | 80133 | 3.2% |
Length
| Max length | 63 |
|---|---|
| Median length | 22 |
| Mean length | 25.51926439 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 10770968 | 16.8% | ||
| t | 8778342 | 13.7% | |
| a | 6073454 | 9.5% | |
| S | 4429118 | 6.9% | |
| e | 3371135 | 5.3% | |
| r | 3134014 | 4.9% | |
| n | 3036622 | 4.7% | |
| o | 2540444 | 4.0% | |
| i | 1855330 | 2.9% | |
| l | 1749711 | 2.7% | |
| s | 1493751 | 2.3% | |
| h | 1391593 | 2.2% | |
| d | 1154115 | 1.8% | |
| c | 884280 | 1.4% | |
| B | 859934 | 1.3% | |
| A | 796863 | 1.2% | |
| y | 723039 | 1.1% | |
| k | 674159 | 1.1% | |
| v | 630303 | 1.0% | |
| T | 620742 | 1.0% | |
| M | 614401 | 1.0% | |
| P | 543646 | 0.8% | |
| F | 453604 | 0.7% | |
| m | 447275 | 0.7% | |
| w | 438080 | 0.7% | |
| Other values (42) | 6511439 | 10.2% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 39929718 | 62.4% | |
| Space Separator | 10770968 | 16.8% | |
| Uppercase Letter | 10643290 | 16.6% | |
| Decimal Number | 1855661 | 2.9% | |
| Open Punctuation | 366393 | 0.6% | |
| Close Punctuation | 366393 | 0.6% | |
| Other Punctuation | 43882 | 0.1% | |
| Dash Punctuation | 57 | < 0.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| S | 4429118 | 41.6% | |
| B | 859934 | 8.1% | |
| A | 796863 | 7.5% | |
| T | 620742 | 5.8% | |
| M | 614401 | 5.8% | |
| P | 543646 | 5.1% | |
| F | 453604 | 4.3% | |
| C | 416586 | 3.9% | |
| R | 323208 | 3.0% | |
| H | 315983 | 3.0% | |
| E | 179890 | 1.7% | |
| D | 151517 | 1.4% | |
| V | 147822 | 1.4% | |
| G | 140555 | 1.3% | |
| W | 137097 | 1.3% | |
| N | 93299 | 0.9% | |
| J | 90325 | 0.8% | |
| K | 86915 | 0.8% | |
| L | 80583 | 0.8% | |
| U | 59771 | 0.6% | |
| O | 58020 | 0.5% | |
| I | 31344 | 0.3% | |
| Y | 12003 | 0.1% | |
| Q | 64 | < 0.1% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| t | 8778342 | 22.0% | |
| a | 6073454 | 15.2% | |
| e | 3371135 | 8.4% | |
| r | 3134014 | 7.8% | |
| n | 3036622 | 7.6% | |
| o | 2540444 | 6.4% | |
| i | 1855330 | 4.6% | |
| l | 1749711 | 4.4% | |
| s | 1493751 | 3.7% | |
| h | 1391593 | 3.5% | |
| d | 1154115 | 2.9% | |
| c | 884280 | 2.2% | |
| y | 723039 | 1.8% | |
| k | 674159 | 1.7% | |
| v | 630303 | 1.6% | |
| m | 447275 | 1.1% | |
| w | 438080 | 1.1% | |
| u | 435219 | 1.1% | |
| g | 397605 | 1.0% | |
| b | 289580 | 0.7% | |
| p | 150161 | 0.4% | |
| z | 122528 | 0.3% | |
| f | 104025 | 0.3% | |
| q | 37924 | 0.1% | |
| j | 10514 | < 0.1% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 10770968 | 100.0% |
Most frequent Open Punctuation characters
| Value | Count | Frequency (%) | |
| ( | 366393 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 1 | 416820 | 22.5% | |
| 2 | 357586 | 19.3% | |
| 4 | 303569 | 16.4% | |
| 5 | 175113 | 9.4% | |
| 7 | 136498 | 7.4% | |
| 3 | 115028 | 6.2% | |
| 0 | 106214 | 5.7% | |
| 9 | 88065 | 4.7% | |
| 6 | 78822 | 4.2% | |
| 8 | 77946 | 4.2% |
Most frequent Close Punctuation characters
| Value | Count | Frequency (%) | |
| ) | 366393 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| / | 23930 | 54.5% | |
| ' | 13283 | 30.3% | |
| & | 6669 | 15.2% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 57 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 50573008 | 79.0% | |
| Common | 13403354 | 21.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| t | 8778342 | 17.4% | |
| a | 6073454 | 12.0% | |
| S | 4429118 | 8.8% | |
| e | 3371135 | 6.7% | |
| r | 3134014 | 6.2% | |
| n | 3036622 | 6.0% | |
| o | 2540444 | 5.0% | |
| i | 1855330 | 3.7% | |
| l | 1749711 | 3.5% | |
| s | 1493751 | 3.0% | |
| h | 1391593 | 2.8% | |
| d | 1154115 | 2.3% | |
| c | 884280 | 1.7% | |
| B | 859934 | 1.7% | |
| A | 796863 | 1.6% | |
| y | 723039 | 1.4% | |
| k | 674159 | 1.3% | |
| v | 630303 | 1.2% | |
| T | 620742 | 1.2% | |
| M | 614401 | 1.2% | |
| P | 543646 | 1.1% | |
| F | 453604 | 0.9% | |
| m | 447275 | 0.9% | |
| w | 438080 | 0.9% | |
| u | 435219 | 0.9% | |
| Other values (25) | 3443834 | 6.8% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 10770968 | 80.4% | ||
| 1 | 416820 | 3.1% | |
| ( | 366393 | 2.7% | |
| ) | 366393 | 2.7% | |
| 2 | 357586 | 2.7% | |
| 4 | 303569 | 2.3% | |
| 5 | 175113 | 1.3% | |
| 7 | 136498 | 1.0% | |
| 3 | 115028 | 0.9% | |
| 0 | 106214 | 0.8% | |
| 9 | 88065 | 0.7% | |
| 6 | 78822 | 0.6% | |
| 8 | 77946 | 0.6% | |
| / | 23930 | 0.2% | |
| ' | 13283 | 0.1% | |
| & | 6669 | < 0.1% | |
| - | 57 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 63976362 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 10770968 | 16.8% | ||
| t | 8778342 | 13.7% | |
| a | 6073454 | 9.5% | |
| S | 4429118 | 6.9% | |
| e | 3371135 | 5.3% | |
| r | 3134014 | 4.9% | |
| n | 3036622 | 4.7% | |
| o | 2540444 | 4.0% | |
| i | 1855330 | 2.9% | |
| l | 1749711 | 2.7% | |
| s | 1493751 | 2.3% | |
| h | 1391593 | 2.2% | |
| d | 1154115 | 1.8% | |
| c | 884280 | 1.4% | |
| B | 859934 | 1.3% | |
| A | 796863 | 1.2% | |
| y | 723039 | 1.1% | |
| k | 674159 | 1.1% | |
| v | 630303 | 1.0% | |
| T | 620742 | 1.0% | |
| M | 614401 | 1.0% | |
| P | 543646 | 0.8% | |
| F | 453604 | 0.7% | |
| m | 447275 | 0.7% | |
| w | 438080 | 0.7% | |
| Other values (42) | 6511439 | 10.2% |
| Distinct count | 74719 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.7650637139919 |
|---|---|
| Minimum | 0.0 |
| Maximum | 45.51 |
| Zeros | 12 |
| Zeros (%) | < 0.1% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 37.3448821 |
| Q1 | 37.7693053 |
| median | 37.780526 |
| Q3 | 37.79539294 |
| 95-th percentile | 37.866249 |
| Maximum | 45.51 |
| Range | 45.51 |
| Interquartile range (IQR) | 0.0260876373 |
Descriptive statistics
| Standard deviation | 0.13636983 |
|---|---|
| Coefficient of variation (CV) | 0.003611004898 |
| Kurtosis | 28171.78928 |
| Mean | 37.76506371 |
| Median Absolute Deviation (MAD) | 0.013604 |
| Skewness | -103.0494041 |
| Sum | 94676372.72 |
| Variance | 0.01859673054 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 37.776619 | 45058 | 1.8% | |
| 37.77588 | 42962 | 1.7% | |
| 37.776598 | 40303 | 1.6% | |
| 37.795392 | 39016 | 1.6% | |
| 37.7766392 | 36576 | 1.5% | |
| 37.7896254 | 36081 | 1.4% | |
| 37.78637527 | 34253 | 1.4% | |
| 37.79413 | 32448 | 1.3% | |
| 37.789756 | 31341 | 1.3% | |
| 37.78389936 | 30581 | 1.2% | |
| 37.80477 | 28785 | 1.1% | |
| 37.780526 | 24424 | 1.0% | |
| 37.77874161 | 23093 | 0.9% | |
| 37.792251 | 22094 | 0.9% | |
| 37.7704074 | 21437 | 0.9% | |
| 37.771058 | 21116 | 0.8% | |
| 37.7880593 | 20818 | 0.8% | |
| 37.7810737 | 20551 | 0.8% | |
| 37.76704458 | 20015 | 0.8% | |
| 37.791464 | 19221 | 0.8% | |
| 37.7765126 | 18335 | 0.7% | |
| 37.8693603 | 17302 | 0.7% | |
| 37.788975 | 17158 | 0.7% | |
| 37.7644783 | 17100 | 0.7% | |
| 37.77143136 | 16127 | 0.6% | |
| Other values (74694) | 1830788 | 73.0% |
| Value | Count | Frequency (%) | |
| 0 | 12 | < 0.1% | |
| 36.16326117 | 1 | < 0.1% | |
| 36.163307 | 1 | < 0.1% | |
| 36.16331083 | 1 | < 0.1% | |
| 36.163449 | 1 | < 0.1% | |
| 36.16358 | 1 | < 0.1% | |
| 37.26804867 | 1 | < 0.1% | |
| 37.27951833 | 1 | < 0.1% | |
| 37.2796155 | 1 | < 0.1% | |
| 37.27962767 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 45.51 | 4 | < 0.1% | |
| 39.8925671 | 2 | < 0.1% | |
| 37.89530017 | 1 | < 0.1% | |
| 37.89218667 | 1 | < 0.1% | |
| 37.89129667 | 1 | < 0.1% | |
| 37.8882145 | 1 | < 0.1% | |
| 37.88805183 | 1 | < 0.1% | |
| 37.88579167 | 1 | < 0.1% | |
| 37.88577283 | 1 | < 0.1% | |
| 37.88575283 | 1 | < 0.1% |
| Distinct count | 75943 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.3499194884997 |
|---|---|
| Minimum | -122.5142991667 |
| Maximum | 0.0 |
| Zeros | 12 |
| Zeros (%) | < 0.1% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | -122.5142992 |
|---|---|
| 5-th percentile | -122.4335369 |
| Q1 | -122.4130036 |
| median | -122.3982847 |
| Q3 | -122.2914153 |
| 95-th percentile | -121.9086179 |
| Maximum | 0 |
| Range | 122.5142992 |
| Interquartile range (IQR) | 0.1215883 |
Descriptive statistics
| Standard deviation | 0.3089648379 |
|---|---|
| Coefficient of variation (CV) | -0.002525255751 |
| Kurtosis | 119481.8018 |
| Mean | -122.3499195 |
| Median Absolute Deviation (MAD) | 0.0165324263 |
| Skewness | 309.5870215 |
| Sum | -306729168.2 |
| Variance | 0.09545927105 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| -122.417385 | 45058 | 1.8% | |
| -122.39317 | 42962 | 1.7% | |
| -122.395282 | 40302 | 1.6% | |
| -122.394203 | 39016 | 1.6% | |
| -122.3955263 | 36576 | 1.5% | |
| -122.400811 | 36081 | 1.4% | |
| -122.4049044 | 34253 | 1.4% | |
| -122.39443 | 32448 | 1.3% | |
| -122.394643 | 31341 | 1.3% | |
| -122.4084449 | 30581 | 1.2% | |
| -122.403234 | 28785 | 1.1% | |
| -122.390288 | 24424 | 1.0% | |
| -122.3927408 | 23093 | 0.9% | |
| -122.397086 | 22094 | 0.9% | |
| -122.3911984 | 21437 | 0.9% | |
| -122.402717 | 21116 | 0.8% | |
| -122.3918648 | 20818 | 0.8% | |
| -122.4117382 | 20551 | 0.8% | |
| -122.3908335 | 20015 | 0.8% | |
| -122.391034 | 19219 | 0.8% | |
| -122.4113061 | 18335 | 0.7% | |
| -122.2543374 | 17302 | 0.7% | |
| -122.403452 | 17158 | 0.7% | |
| -122.4025701 | 17100 | 0.7% | |
| -122.4057868 | 16127 | 0.6% | |
| Other values (75918) | 1830791 | 73.0% |
| Value | Count | Frequency (%) | |
| -122.5142992 | 1 | < 0.1% | |
| -122.513847 | 1 | < 0.1% | |
| -122.5138378 | 1 | < 0.1% | |
| -122.5138162 | 1 | < 0.1% | |
| -122.5137985 | 1 | < 0.1% | |
| -122.5137767 | 1 | < 0.1% | |
| -122.5131427 | 1 | < 0.1% | |
| -122.5119482 | 1 | < 0.1% | |
| -122.5117435 | 1 | < 0.1% | |
| -122.5117097 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 12 | < 0.1% | |
| -73.57 | 4 | < 0.1% | |
| -75.17371416 | 2 | < 0.1% | |
| -86.77517717 | 1 | < 0.1% | |
| -86.77563417 | 1 | < 0.1% | |
| -86.7757685 | 1 | < 0.1% | |
| -86.77581167 | 1 | < 0.1% | |
| -86.77601767 | 1 | < 0.1% | |
| -121.8117485 | 1 | < 0.1% | |
| -121.8134252 | 1 | < 0.1% |
| Distinct count | 436 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 82902 |
| Missing (%) | 3.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 142.70442406833766 |
|---|---|
| Minimum | 3.0 |
| Maximum | 498.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 43 |
| median | 101 |
| Q3 | 239 |
| 95-th percentile | 373 |
| Maximum | 498 |
| Range | 495 |
| Interquartile range (IQR) | 196 |
Descriptive statistics
| Standard deviation | 121.4296491 |
|---|---|
| Coefficient of variation (CV) | 0.8509172009 |
| Kurtosis | -0.4842603229 |
| Mean | 142.7044241 |
| Median Absolute Deviation (MAD) | 78 |
| Skewness | 0.8058184619 |
| Sum | 345927083 |
| Variance | 14745.15968 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 67 | 52146 | 2.1% | |
| 30 | 50943 | 2.0% | |
| 15 | 48180 | 1.9% | |
| 21 | 47886 | 1.9% | |
| 58 | 44284 | 1.8% | |
| 81 | 42231 | 1.7% | |
| 3 | 37466 | 1.5% | |
| 16 | 33319 | 1.3% | |
| 6 | 33286 | 1.3% | |
| 5 | 31540 | 1.3% | |
| 22 | 29459 | 1.2% | |
| 50 | 25677 | 1.0% | |
| 93 | 25046 | 1.0% | |
| 90 | 23342 | 0.9% | |
| 44 | 23208 | 0.9% | |
| 17 | 22223 | 0.9% | |
| 66 | 21713 | 0.9% | |
| 27 | 21621 | 0.9% | |
| 350 | 19984 | 0.8% | |
| 104 | 19925 | 0.8% | |
| 23 | 19736 | 0.8% | |
| 61 | 19002 | 0.8% | |
| 19 | 18111 | 0.7% | |
| 114 | 18054 | 0.7% | |
| 182 | 17093 | 0.7% | |
| Other values (411) | 1678606 | 67.0% | |
| (Missing) | 82902 | 3.3% |
| Value | Count | Frequency (%) | |
| 3 | 37466 | 1.5% | |
| 4 | 7263 | 0.3% | |
| 5 | 31540 | 1.3% | |
| 6 | 33286 | 1.3% | |
| 7 | 9646 | 0.4% | |
| 8 | 10721 | 0.4% | |
| 9 | 10079 | 0.4% | |
| 10 | 11198 | 0.4% | |
| 11 | 12162 | 0.5% | |
| 12 | 3284 | 0.1% |
| Value | Count | Frequency (%) | |
| 498 | 10 | < 0.1% | |
| 495 | 24 | < 0.1% | |
| 494 | 11 | < 0.1% | |
| 493 | 360 | < 0.1% | |
| 492 | 33 | < 0.1% | |
| 491 | 10 | < 0.1% | |
| 490 | 58 | < 0.1% | |
| 489 | 67 | < 0.1% | |
| 488 | 12 | < 0.1% | |
| 487 | 329 | < 0.1% |
| Distinct count | 446 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 82350 |
| Missing (%) | 3.3% |
| Memory size | 19.1 MiB |
| San Francisco Caltrain Station 2 (Townsend St at 4th St) | 52146 |
|---|---|
| San Francisco Caltrain (Townsend St at 4th St) | 50943 |
| San Francisco Ferry Building (Harry Bridges Plaza) | 48180 |
| Montgomery St BART Station (Market St at 2nd St) | 47886 |
| Market St at 10th St | 44284 |
| Other values (441) |
| Value | Count | Frequency (%) | |
| San Francisco Caltrain Station 2 (Townsend St at 4th St) | 52146 | 2.1% | |
| San Francisco Caltrain (Townsend St at 4th St) | 50943 | 2.0% | |
| San Francisco Ferry Building (Harry Bridges Plaza) | 48180 | 1.9% | |
| Montgomery St BART Station (Market St at 2nd St) | 47886 | 1.9% | |
| Market St at 10th St | 44284 | 1.8% | |
| Berry St at 4th St | 42231 | 1.7% | |
| Powell St BART Station (Market St at 4th St) | 37466 | 1.5% | |
| Steuart St at Market St | 33319 | 1.3% | |
| The Embarcadero at Sansome St | 33286 | 1.3% | |
| Powell St BART Station (Market St at 5th St) | 31540 | 1.3% | |
| Howard St at Beale St | 29459 | 1.2% | |
| 2nd St at Townsend St | 25677 | 1.0% | |
| 4th St at Mission Bay Blvd S | 25046 | 1.0% | |
| Townsend St at 7th St | 23342 | 0.9% | |
| Civic Center/UN Plaza BART Station (Market St at McAllister St) | 23208 | 0.9% | |
| Embarcadero BART Station (Beale St at Market St) | 22223 | 0.9% | |
| 3rd St at Townsend St | 21713 | 0.9% | |
| Beale St at Harrison St | 21621 | 0.9% | |
| 8th St at Brannan St | 19984 | 0.8% | |
| 4th St at 16th St | 19925 | 0.8% | |
| The Embarcadero at Steuart St | 19736 | 0.8% | |
| Howard St at 8th St | 19002 | 0.8% | |
| Post St at Kearny St | 18111 | 0.7% | |
| Rhode Island St at 17th St | 18054 | 0.7% | |
| 19th Street BART Station | 17093 | 0.7% | |
| Other values (421) | 1679158 | 67.0% | |
| (Missing) | 82350 | 3.3% |
Length
| Max length | 63 |
|---|---|
| Median length | 22 |
| Mean length | 26.1590633 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 11012180 | 16.8% | ||
| t | 8929686 | 13.6% | |
| a | 6220131 | 9.5% | |
| S | 4536711 | 6.9% | |
| e | 3306264 | 5.0% | |
| n | 3273585 | 5.0% | |
| r | 3208579 | 4.9% | |
| o | 2603744 | 4.0% | |
| i | 1992641 | 3.0% | |
| l | 1735652 | 2.6% | |
| s | 1552276 | 2.4% | |
| h | 1425648 | 2.2% | |
| d | 1197318 | 1.8% | |
| c | 927313 | 1.4% | |
| B | 892946 | 1.4% | |
| A | 789425 | 1.2% | |
| y | 738928 | 1.1% | |
| T | 672517 | 1.0% | |
| k | 660464 | 1.0% | |
| M | 642164 | 1.0% | |
| v | 600912 | 0.9% | |
| P | 541199 | 0.8% | |
| F | 494156 | 0.8% | |
| m | 481648 | 0.7% | |
| w | 459319 | 0.7% | |
| Other values (42) | 6684921 | 10.2% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 40873107 | 62.3% | |
| Space Separator | 11012180 | 16.8% | |
| Uppercase Letter | 10889086 | 16.6% | |
| Decimal Number | 1923889 | 2.9% | |
| Open Punctuation | 418734 | 0.6% | |
| Close Punctuation | 418734 | 0.6% | |
| Other Punctuation | 44541 | 0.1% | |
| Dash Punctuation | 56 | < 0.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| S | 4536711 | 41.7% | |
| B | 892946 | 8.2% | |
| A | 789425 | 7.2% | |
| T | 672517 | 6.2% | |
| M | 642164 | 5.9% | |
| P | 541199 | 5.0% | |
| F | 494156 | 4.5% | |
| C | 420495 | 3.9% | |
| R | 344172 | 3.2% | |
| H | 311824 | 2.9% | |
| E | 182793 | 1.7% | |
| V | 146015 | 1.3% | |
| D | 141213 | 1.3% | |
| W | 131801 | 1.2% | |
| G | 131220 | 1.2% | |
| N | 99938 | 0.9% | |
| K | 84447 | 0.8% | |
| J | 82514 | 0.8% | |
| L | 79593 | 0.7% | |
| U | 65742 | 0.6% | |
| O | 52851 | 0.5% | |
| I | 33417 | 0.3% | |
| Y | 11891 | 0.1% | |
| Q | 42 | < 0.1% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| t | 8929686 | 21.8% | |
| a | 6220131 | 15.2% | |
| e | 3306264 | 8.1% | |
| n | 3273585 | 8.0% | |
| r | 3208579 | 7.9% | |
| o | 2603744 | 6.4% | |
| i | 1992641 | 4.9% | |
| l | 1735652 | 4.2% | |
| s | 1552276 | 3.8% | |
| h | 1425648 | 3.5% | |
| d | 1197318 | 2.9% | |
| c | 927313 | 2.3% | |
| y | 738928 | 1.8% | |
| k | 660464 | 1.6% | |
| v | 600912 | 1.5% | |
| m | 481648 | 1.2% | |
| w | 459319 | 1.1% | |
| u | 438243 | 1.1% | |
| g | 400857 | 1.0% | |
| b | 296426 | 0.7% | |
| p | 141434 | 0.3% | |
| z | 132335 | 0.3% | |
| f | 96627 | 0.2% | |
| q | 34958 | 0.1% | |
| j | 10721 | < 0.1% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 11012180 | 100.0% |
Most frequent Open Punctuation characters
| Value | Count | Frequency (%) | |
| ( | 418734 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 1 | 427957 | 22.2% | |
| 2 | 376825 | 19.6% | |
| 4 | 330311 | 17.2% | |
| 5 | 170819 | 8.9% | |
| 7 | 143214 | 7.4% | |
| 3 | 115785 | 6.0% | |
| 0 | 104264 | 5.4% | |
| 9 | 90111 | 4.7% | |
| 8 | 82573 | 4.3% | |
| 6 | 82030 | 4.3% |
Most frequent Close Punctuation characters
| Value | Count | Frequency (%) | |
| ) | 418734 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| / | 26492 | 59.5% | |
| ' | 10510 | 23.6% | |
| & | 7539 | 16.9% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 56 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 51762193 | 78.9% | |
| Common | 13818134 | 21.1% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| t | 8929686 | 17.3% | |
| a | 6220131 | 12.0% | |
| S | 4536711 | 8.8% | |
| e | 3306264 | 6.4% | |
| n | 3273585 | 6.3% | |
| r | 3208579 | 6.2% | |
| o | 2603744 | 5.0% | |
| i | 1992641 | 3.8% | |
| l | 1735652 | 3.4% | |
| s | 1552276 | 3.0% | |
| h | 1425648 | 2.8% | |
| d | 1197318 | 2.3% | |
| c | 927313 | 1.8% | |
| B | 892946 | 1.7% | |
| A | 789425 | 1.5% | |
| y | 738928 | 1.4% | |
| T | 672517 | 1.3% | |
| k | 660464 | 1.3% | |
| M | 642164 | 1.2% | |
| v | 600912 | 1.2% | |
| P | 541199 | 1.0% | |
| F | 494156 | 1.0% | |
| m | 481648 | 0.9% | |
| w | 459319 | 0.9% | |
| u | 438243 | 0.8% | |
| Other values (25) | 3440724 | 6.6% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 11012180 | 79.7% | ||
| 1 | 427957 | 3.1% | |
| ( | 418734 | 3.0% | |
| ) | 418734 | 3.0% | |
| 2 | 376825 | 2.7% | |
| 4 | 330311 | 2.4% | |
| 5 | 170819 | 1.2% | |
| 7 | 143214 | 1.0% | |
| 3 | 115785 | 0.8% | |
| 0 | 104264 | 0.8% | |
| 9 | 90111 | 0.7% | |
| 8 | 82573 | 0.6% | |
| 6 | 82030 | 0.6% | |
| / | 26492 | 0.2% | |
| ' | 10510 | 0.1% | |
| & | 7539 | 0.1% | |
| - | 56 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 65580327 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 11012180 | 16.8% | ||
| t | 8929686 | 13.6% | |
| a | 6220131 | 9.5% | |
| S | 4536711 | 6.9% | |
| e | 3306264 | 5.0% | |
| n | 3273585 | 5.0% | |
| r | 3208579 | 4.9% | |
| o | 2603744 | 4.0% | |
| i | 1992641 | 3.0% | |
| l | 1735652 | 2.6% | |
| s | 1552276 | 2.4% | |
| h | 1425648 | 2.2% | |
| d | 1197318 | 1.8% | |
| c | 927313 | 1.4% | |
| B | 892946 | 1.4% | |
| A | 789425 | 1.2% | |
| y | 738928 | 1.1% | |
| T | 672517 | 1.0% | |
| k | 660464 | 1.0% | |
| M | 642164 | 1.0% | |
| v | 600912 | 0.9% | |
| P | 541199 | 0.8% | |
| F | 494156 | 0.8% | |
| m | 481648 | 0.7% | |
| w | 459319 | 0.7% | |
| Other values (42) | 6684921 | 10.2% |
| Distinct count | 76905 |
|---|---|
| Unique (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.76421902594531 |
|---|---|
| Minimum | 0.0 |
| Maximum | 45.51 |
| Zeros | 80 |
| Zeros (%) | < 0.1% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 37.3448821 |
| Q1 | 37.7700298 |
| median | 37.7807601 |
| Q3 | 37.79587283 |
| 95-th percentile | 37.8660431 |
| Maximum | 45.51 |
| Range | 45.51 |
| Interquartile range (IQR) | 0.0258430333 |
Descriptive statistics
| Standard deviation | 0.2392885015 |
|---|---|
| Coefficient of variation (CV) | 0.006336381572 |
| Kurtosis | 19795.20156 |
| Mean | 37.76421903 |
| Median Absolute Deviation (MAD) | 0.0137155203 |
| Skewness | -125.689168 |
| Sum | 94674255.11 |
| Variance | 0.05725898695 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 37.7766392 | 52146 | 2.1% | |
| 37.776598 | 50943 | 2.0% | |
| 37.795392 | 48180 | 1.9% | |
| 37.7896254 | 47886 | 1.9% | |
| 37.776619 | 44284 | 1.8% | |
| 37.77588 | 42232 | 1.7% | |
| 37.78637527 | 37466 | 1.5% | |
| 37.79413 | 33319 | 1.3% | |
| 37.80477 | 33286 | 1.3% | |
| 37.78389936 | 31540 | 1.3% | |
| 37.789756 | 29459 | 1.2% | |
| 37.780526 | 25677 | 1.0% | |
| 37.7704074 | 25046 | 1.0% | |
| 37.771058 | 23342 | 0.9% | |
| 37.7810737 | 23208 | 0.9% | |
| 37.792251 | 22223 | 0.9% | |
| 37.77874161 | 21713 | 0.9% | |
| 37.7880593 | 21621 | 0.9% | |
| 37.77143136 | 19984 | 0.8% | |
| 37.76704458 | 19925 | 0.8% | |
| 37.791464 | 19736 | 0.8% | |
| 37.7765126 | 19002 | 0.8% | |
| 37.788975 | 18112 | 0.7% | |
| 37.7644783 | 18054 | 0.7% | |
| 37.870139 | 16405 | 0.7% | |
| Other values (76880) | 1762194 | 70.3% |
| Value | Count | Frequency (%) | |
| 0 | 80 | < 0.1% | |
| 36.16314 | 1 | < 0.1% | |
| 36.16338533 | 1 | < 0.1% | |
| 36.1634205 | 1 | < 0.1% | |
| 36.16345967 | 1 | < 0.1% | |
| 36.16358 | 1 | < 0.1% | |
| 36.73953817 | 1 | < 0.1% | |
| 37.22610033 | 1 | < 0.1% | |
| 37.244987 | 1 | < 0.1% | |
| 37.2464625 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 45.51 | 4 | < 0.1% | |
| 39.8925671 | 2 | < 0.1% | |
| 37.91295533 | 1 | < 0.1% | |
| 37.91285367 | 1 | < 0.1% | |
| 37.90295133 | 1 | < 0.1% | |
| 37.89987783 | 1 | < 0.1% | |
| 37.8998715 | 1 | < 0.1% | |
| 37.89986517 | 1 | < 0.1% | |
| 37.89524017 | 1 | < 0.1% | |
| 37.89217 | 1 | < 0.1% |
| Distinct count | 77995 |
|---|---|
| Unique (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.34590784656719 |
|---|---|
| Minimum | -122.5142868333 |
| Maximum | 0.0 |
| Zeros | 80 |
| Zeros (%) | < 0.1% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | -122.5142868 |
|---|---|
| 5-th percentile | -122.4310597 |
| Q1 | -122.4117258 |
| median | -122.398113 |
| Q3 | -122.2933996 |
| 95-th percentile | -121.9086179 |
| Maximum | 0 |
| Range | 122.5142868 |
| Interquartile range (IQR) | 0.1183262276 |
Descriptive statistics
| Standard deviation | 0.708041743 |
|---|---|
| Coefficient of variation (CV) | -0.005787212302 |
| Kurtosis | 28510.04618 |
| Mean | -122.3459078 |
| Median Absolute Deviation (MAD) | 0.0136251877 |
| Skewness | 165.6630369 |
| Sum | -306719111.1 |
| Variance | 0.5013231098 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| -122.3955263 | 52146 | 2.1% | |
| -122.395282 | 50943 | 2.0% | |
| -122.394203 | 48180 | 1.9% | |
| -122.400811 | 47886 | 1.9% | |
| -122.417385 | 44284 | 1.8% | |
| -122.39317 | 42231 | 1.7% | |
| -122.4049044 | 37466 | 1.5% | |
| -122.39443 | 33319 | 1.3% | |
| -122.403234 | 33286 | 1.3% | |
| -122.4084449 | 31540 | 1.3% | |
| -122.394643 | 29459 | 1.2% | |
| -122.390288 | 25677 | 1.0% | |
| -122.3911984 | 25046 | 1.0% | |
| -122.402717 | 23342 | 0.9% | |
| -122.4117382 | 23208 | 0.9% | |
| -122.397086 | 22223 | 0.9% | |
| -122.3927408 | 21713 | 0.9% | |
| -122.3918648 | 21621 | 0.9% | |
| -122.4057868 | 19984 | 0.8% | |
| -122.3908335 | 19925 | 0.8% | |
| -122.391034 | 19736 | 0.8% | |
| -122.4113061 | 19002 | 0.8% | |
| -122.403452 | 18111 | 0.7% | |
| -122.4025701 | 18054 | 0.7% | |
| -122.268422 | 16405 | 0.7% | |
| Other values (77970) | 1762196 | 70.3% |
| Value | Count | Frequency (%) | |
| -122.5142868 | 1 | < 0.1% | |
| -122.5138242 | 1 | < 0.1% | |
| -122.5138193 | 1 | < 0.1% | |
| -122.513818 | 1 | < 0.1% | |
| -122.5138032 | 1 | < 0.1% | |
| -122.5138008 | 1 | < 0.1% | |
| -122.5137905 | 1 | < 0.1% | |
| -122.5131595 | 1 | < 0.1% | |
| -122.5124662 | 1 | < 0.1% | |
| -122.5119483 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 80 | < 0.1% | |
| -73.57 | 4 | < 0.1% | |
| -75.17371416 | 2 | < 0.1% | |
| -86.77517717 | 1 | < 0.1% | |
| -86.77572833 | 1 | < 0.1% | |
| -86.7757935 | 1 | < 0.1% | |
| -86.77580517 | 1 | < 0.1% | |
| -86.7758545 | 1 | < 0.1% | |
| -121.469453 | 1 | < 0.1% | |
| -121.7336153 | 1 | < 0.1% |
bike_id
Real number (ℝ≥0)
| Distinct count | 11070 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27898.32716177174 |
|---|---|
| Minimum | 4 |
| Maximum | 999941 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.1 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 399 |
| Q1 | 1952 |
| median | 4420 |
| Q3 | 9682 |
| 95-th percentile | 13066 |
| Maximum | 999941 |
| Range | 999937 |
| Interquartile range (IQR) | 7730 |
Descriptive statistics
| Standard deviation | 114606.6512 |
|---|---|
| Coefficient of variation (CV) | 4.108011585 |
| Kurtosis | 32.60656269 |
| Mean | 27898.32716 |
| Median Absolute Deviation (MAD) | 2711 |
| Skewness | 5.589032711 |
| Sum | 6.994063192e+10 |
| Variance | 1.31346845e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3135 | 912 | < 0.1% | |
| 3146 | 911 | < 0.1% | |
| 3569 | 889 | < 0.1% | |
| 3249 | 882 | < 0.1% | |
| 1502 | 882 | < 0.1% | |
| 3009 | 874 | < 0.1% | |
| 1406 | 871 | < 0.1% | |
| 2174 | 866 | < 0.1% | |
| 2692 | 862 | < 0.1% | |
| 2293 | 862 | < 0.1% | |
| 1258 | 861 | < 0.1% | |
| 27 | 855 | < 0.1% | |
| 1566 | 850 | < 0.1% | |
| 2119 | 848 | < 0.1% | |
| 2497 | 848 | < 0.1% | |
| 1396 | 844 | < 0.1% | |
| 1044 | 840 | < 0.1% | |
| 1368 | 840 | < 0.1% | |
| 3147 | 838 | < 0.1% | |
| 1667 | 837 | < 0.1% | |
| 3589 | 835 | < 0.1% | |
| 3379 | 832 | < 0.1% | |
| 1886 | 830 | < 0.1% | |
| 3491 | 830 | < 0.1% | |
| 1821 | 828 | < 0.1% | |
| Other values (11045) | 2485556 | 99.1% |
| Value | Count | Frequency (%) | |
| 4 | 2 | < 0.1% | |
| 11 | 211 | < 0.1% | |
| 12 | 570 | < 0.1% | |
| 13 | 645 | < 0.1% | |
| 14 | 321 | < 0.1% | |
| 15 | 103 | < 0.1% | |
| 17 | 322 | < 0.1% | |
| 18 | 377 | < 0.1% | |
| 22 | 384 | < 0.1% | |
| 24 | 212 | < 0.1% |
| Value | Count | Frequency (%) | |
| 999941 | 15 | < 0.1% | |
| 999937 | 4 | < 0.1% | |
| 999422 | 35 | < 0.1% | |
| 998430 | 36 | < 0.1% | |
| 998086 | 25 | < 0.1% | |
| 997397 | 84 | < 0.1% | |
| 996963 | 30 | < 0.1% | |
| 996564 | 48 | < 0.1% | |
| 995091 | 62 | < 0.1% | |
| 993240 | 7 | < 0.1% |
user_type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.1 MiB |
| Subscriber | |
|---|---|
| Customer |
| Value | Count | Frequency (%) | |
| Subscriber | 2021166 | 80.6% | |
| Customer | 485817 | 19.4% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.612428963 |
| Min length | 8 |
Most occurring characters
| Value | Count | Frequency (%) | |
| r | 4528149 | 18.8% | |
| b | 4042332 | 16.8% | |
| u | 2506983 | 10.4% | |
| s | 2506983 | 10.4% | |
| e | 2506983 | 10.4% | |
| S | 2021166 | 8.4% | |
| c | 2021166 | 8.4% | |
| i | 2021166 | 8.4% | |
| C | 485817 | 2.0% | |
| t | 485817 | 2.0% | |
| o | 485817 | 2.0% | |
| m | 485817 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 21591213 | 89.6% | |
| Uppercase Letter | 2506983 | 10.4% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| S | 2021166 | 80.6% | |
| C | 485817 | 19.4% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| r | 4528149 | 21.0% | |
| b | 4042332 | 18.7% | |
| u | 2506983 | 11.6% | |
| s | 2506983 | 11.6% | |
| e | 2506983 | 11.6% | |
| c | 2021166 | 9.4% | |
| i | 2021166 | 9.4% | |
| t | 485817 | 2.3% | |
| o | 485817 | 2.3% | |
| m | 485817 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 24098196 | 100.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| r | 4528149 | 18.8% | |
| b | 4042332 | 16.8% | |
| u | 2506983 | 10.4% | |
| s | 2506983 | 10.4% | |
| e | 2506983 | 10.4% | |
| S | 2021166 | 8.4% | |
| c | 2021166 | 8.4% | |
| i | 2021166 | 8.4% | |
| C | 485817 | 2.0% | |
| t | 485817 | 2.0% | |
| o | 485817 | 2.0% | |
| m | 485817 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 24098196 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| r | 4528149 | 18.8% | |
| b | 4042332 | 16.8% | |
| u | 2506983 | 10.4% | |
| s | 2506983 | 10.4% | |
| e | 2506983 | 10.4% | |
| S | 2021166 | 8.4% | |
| c | 2021166 | 8.4% | |
| i | 2021166 | 8.4% | |
| C | 485817 | 2.0% | |
| t | 485817 | 2.0% | |
| o | 485817 | 2.0% | |
| m | 485817 | 2.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| duration_sec | start_time | end_time | start_station_id | start_station_name | start_station_latitude | start_station_longitude | end_station_id | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | bike_share_for_all_trip | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 60863 | 2019-09-30 11:48:02.7100 | 2019-10-01 04:42:25.8640 | 465.0 | San Francisco Caltrain Station (King St at 4th St) | 37.776329 | -122.394438 | 465.0 | San Francisco Caltrain Station (King St at 4th St) | 37.776329 | -122.394438 | 12904 | Customer | No |
| 1 | 36019 | 2019-09-30 16:16:32.3530 | 2019-10-01 02:16:51.9820 | 294.0 | Pierce Ave at Market St | 37.327581 | -121.884559 | 443.0 | 3rd St at Keyes St | 37.320866 | -121.876279 | 163 | Customer | No |
| 2 | 5615 | 2019-09-30 23:12:25.9980 | 2019-10-01 00:46:01.9590 | 370.0 | Jones St at Post St | 37.787327 | -122.413278 | 4.0 | Cyril Magnin St at Ellis St | 37.785881 | -122.408915 | 10737 | Customer | No |
| 3 | 1482 | 2019-09-30 23:57:34.6630 | 2019-10-01 00:22:16.8490 | 109.0 | 17th St at Valencia St | 37.763316 | -122.421904 | 460.0 | Terry Francois Blvd at Warriors Way | 37.769095 | -122.386333 | 10346 | Customer | No |
| 4 | 1272 | 2019-09-30 23:53:28.6530 | 2019-10-01 00:14:41.0740 | 95.0 | Sanchez St at 15th St | 37.766219 | -122.431060 | 127.0 | Valencia St at 21st St | 37.756708 | -122.421025 | 1349 | Subscriber | No |
| 5 | 8648 | 2019-09-30 21:43:51.0140 | 2019-10-01 00:07:59.8930 | 11.0 | Davis St at Jackson St | 37.797280 | -122.398436 | 3.0 | Powell St BART Station (Market St at 4th St) | 37.786375 | -122.404904 | 9806 | Customer | No |
| 6 | 644 | 2019-09-30 23:54:43.1040 | 2019-10-01 00:05:27.6560 | 15.0 | San Francisco Ferry Building (Harry Bridges Plaza) | 37.795392 | -122.394203 | 91.0 | Berry St at King St | 37.771762 | -122.398438 | 9963 | Subscriber | No |
| 7 | 459 | 2019-09-30 23:54:42.8650 | 2019-10-01 00:02:22.3630 | 321.0 | 5th St at Folsom | 37.780146 | -122.403071 | 77.0 | 11th St at Natoma St | 37.773507 | -122.416040 | 531 | Subscriber | No |
| 8 | 625 | 2019-09-30 23:49:31.7050 | 2019-09-30 23:59:56.9160 | 16.0 | Steuart St at Market St | 37.794130 | -122.394430 | 80.0 | Townsend St at 5th St | 37.775235 | -122.397437 | 10906 | Subscriber | No |
| 9 | 1177 | 2019-09-30 23:39:34.0880 | 2019-09-30 23:59:11.2090 | 433.0 | Gennessee St at Monterey Blvd | 37.731657 | -122.451122 | 139.0 | Garfield Square (25th St at Harrison St) | 37.751017 | -122.411901 | 11058 | Customer | No |
Last rows
| duration_sec | start_time | end_time | start_station_id | start_station_name | start_station_latitude | start_station_longitude | end_station_id | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | bike_share_for_all_trip | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2506973 | 122 | 2019-02-01 00:17:32.2580 | 2019-02-01 00:19:34.9380 | 119.0 | 18th St at Noe St | 37.761047 | -122.432642 | 120.0 | Mission Dolores Park | 37.761420 | -122.426435 | 4326 | Subscriber | No |
| 2506974 | 249 | 2019-02-01 00:15:12.0670 | 2019-02-01 00:19:21.6990 | 256.0 | Hearst Ave at Euclid Ave | 37.875112 | -122.260553 | 247.0 | Fulton St at Bancroft Way | 37.867789 | -122.265896 | 4642 | Subscriber | No |
| 2506975 | 256 | 2019-02-01 00:12:50.5540 | 2019-02-01 00:17:07.3620 | 241.0 | Ashby BART Station | 37.852477 | -122.270213 | 248.0 | Telegraph Ave at Ashby Ave | 37.855956 | -122.259795 | 4845 | Subscriber | Yes |
| 2506976 | 111 | 2019-02-01 00:14:49.8740 | 2019-02-01 00:16:41.3010 | 324.0 | Union Square (Powell St at Post St) | 37.788300 | -122.408531 | 19.0 | Post St at Kearny St | 37.788975 | -122.403452 | 4832 | Subscriber | No |
| 2506977 | 706 | 2019-02-01 00:04:40.6160 | 2019-02-01 00:16:27.0800 | 138.0 | Jersey St at Church St | 37.750900 | -122.427411 | 78.0 | Folsom St at 9th St | 37.773717 | -122.411647 | 5017 | Subscriber | No |
| 2506978 | 480 | 2019-02-01 00:04:49.7240 | 2019-02-01 00:12:50.0340 | 27.0 | Beale St at Harrison St | 37.788059 | -122.391865 | 324.0 | Union Square (Powell St at Post St) | 37.788300 | -122.408531 | 4832 | Subscriber | No |
| 2506979 | 313 | 2019-02-01 00:05:34.7440 | 2019-02-01 00:10:48.5020 | 21.0 | Montgomery St BART Station (Market St at 2nd St) | 37.789625 | -122.400811 | 66.0 | 3rd St at Townsend St | 37.778742 | -122.392741 | 4960 | Subscriber | No |
| 2506980 | 141 | 2019-02-01 00:06:05.5490 | 2019-02-01 00:08:27.2200 | 278.0 | The Alameda at Bush St | 37.331932 | -121.904888 | 277.0 | Morrison Ave at Julian St | 37.333658 | -121.908586 | 3824 | Subscriber | Yes |
| 2506981 | 139 | 2019-02-01 00:05:34.3600 | 2019-02-01 00:07:54.2870 | 220.0 | San Pablo Ave at MLK Jr Way | 37.811351 | -122.273422 | 216.0 | San Pablo Ave at 27th St | 37.817827 | -122.275698 | 5095 | Subscriber | No |
| 2506982 | 271 | 2019-02-01 00:00:20.6360 | 2019-02-01 00:04:52.0580 | 24.0 | Spear St at Folsom St | 37.789677 | -122.390428 | 37.0 | 2nd St at Folsom St | 37.785000 | -122.395936 | 1057 | Subscriber | No |